Financial Analyst - Budget

Finance & Services Vacaville, California


Description

Summary:  The Travis Credit Union (TCU) Financial Analyst is responsible for developing and implementing analytics and reporting solutions for the Accounting & Finance division of the organization. The Financial Analyst creates value for the organization by synthesizing data from multiple sources and liaising with other departments to share insights with respect to growth trends, profitability, potential efficiencies, and other knowledge which will help run the business more effectively.

Profile:
  • Provides reporting and analytics focused on but not limited to budgeting; asset-liability management modeling (ALM); interest rate risk; liquidity management; balance sheet allocation; profitability; product pricing methodologies; cost-benefit analysis; static pool tracking; dividend verification and deposit analytics; financial trends; and ad-hoc analysis.
  • Maintains and runs various financial analytical software systems and models, both in-house and 3rd party, including but not limited to:  Prologue General Ledger; Vantage Budgeting;   3rd party Asset/Liability Management (ALM) Model; DNA Profit Vision; Visible Equity Loan Analytics; DNA Core; Callahan Peer-to-Peer; Travis Intelligence Database.
  • Reconciles financial data between systems and models to ensure consistent, detailed and summary reporting to be provided to management, ALCO, and other end-users.
  • Monitors and measures risk in accordance with the metrics outlined in TCU’s policies: Asset-Liability Management; Concentration Risk; Investment; Liquidity Management.
  • Coordinates data gathering from each department for annual budget.  Performs quarterly re-forecasts.  Evaluates budget and what-if scenarios versus historical data, performs other budgeting duties as assigned. 
  • Performs profitability analyses and develops pricing models to ensure product offerings are appropriately priced.
  • Ensures Budget, 3rd party ALM Model, Profitability Model, and Loan Analytics Model data is reconciled and uploaded.  Develops and maintains financial analytics and reporting using modeling output.
  • Responsible for: daily share and loan balancing; deposit analytics; quarterly peer analysis; monthly dividend verification; establishing benchmarks for financial performance.
  • Accurately prepares reports for monthly ALCO and Board meetings.
  • Serves as a Finance Liaison to other departments as it relates to other functions and projects.  Serves as TCU Liaison to: third-party software providers; entities that report on our financial data (Callahan, Raddon Financial Group, etc.).
  • Determines methods and procedures on new assignments and may coordinate activities of other personnel for projects.
Skills:  
  • Basic understanding of accounting, balance sheets, income statements, depository institutions, and Asset Liability Management. 
  • Strong analytical skills, highly organized, ability to prioritize workload and manage multiple assignments and deadlines simultaneously.  
  • Reasoning ability - capable of logical, critical thinking.  Ability to use logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusion or approaches to complex problems. Ability to define problems, collect data, establish facts and draw valid conclusions. 
  • Detail-oriented and able to perform functions with accuracy and on rigid schedules.
  • Accuracy and attention to detail are paramount as errors in reporting can lead to material misstatements in both regulatory and public arenas, potentially resulting in financial penalties.
  • Effective, professional verbal and written communication skills. 
  • Ability to work with all levels of the credit union staff. 
  • Proficient in Microsoft Office suite of products.   
  • Advanced Excel skills to include macro experience. 
  • Budgeting software, General Ledger package, and reporting software experience is helpful.
Reporting and Experience
 
Financial Analyst
  • Reports directly to assigned department management.
  • Bachelor's degree in Finance, Accounting, Statistics, Data Analytics Economics, Business, or related field; or an advanced degree without experience; or equivalent related professional experience.
  • Minimum 2 years finance related work experience, preferably in the financial services and/or banking industry.
  • Thorough understanding of financial statements, budgeting, forecasting, and ALM.  Effective use of databases (Tableau, Power BI, or Oracle) using user interface and/or coding languages (e.g., SQL or DAX) to query relevant data.
Senior Financial Analyst
  • Reports directly to assigned department management.
  • Bachelor's degree in Finance, Accounting, Statistics, Data Analytics Economics, Business, or related field and a minimum of 5 years of related work experience; or a Master’s degree and 3 years of experience; or equivalent work experience.
  • Thorough understanding of financial statements, budgeting, forecasting, liquidity forecasting, and ALM.
  • Effective use of databases (Tableau, Power BI, or Oracle) using user interface and/or coding languages (e.g., SQL or DAX) to query relevant data.
Compensation:
  • Financial Analyst:  Grade 15 - Base salary starting range:  $ 78,312.00 /annually - $ 96,720.00 is commensurate with experience.
  • Sr. Financial Analyst:  Grade 17 – Base salary starting range:  $ 93,038.40/annually - $ 114,920.00 is commensurate with experience.
Our compensation philosophy is based on several factors such as (but not limited to) the scope and responsibilities of the position, the candidate's work experience, education/training, and key skills.
 
At Travis Credit Union, our priority is that our employees and their loved ones are provided with a Total Rewards program that insures their health and welfare safety which allows our employees to focus on the financial welfare of our members and the credit unions objectives.  As such,  Travis Credit Union offers a robust benefits package to our eligible employees, including competitive medical, dental, and vision insurance, mental health offerings, employee performance incentive plan, merit increases, 401(k) program with immediately vested employer match, generous holiday and vacation policy, and extensive TCU specific perks like employee loan and credit card discounts!
 
#traviscu